Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 9134 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Text | 1 |
|---|---|
| Categorical | 13 |
| Numeric | 8 |
| Boolean | 1 |
| DateTime | 1 |
customer has unique values | Unique |
income has 2317 (25.4%) zeros | Zeros |
months_since_last_claim has 314 (3.4%) zeros | Zeros |
number_of_open_complaints has 7252 (79.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-01-25 16:19:18.317062 |
|---|---|
| Analysis finished | 2024-01-25 16:19:28.020493 |
| Duration | 9.7 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
customer
Text
UNIQUE
| Distinct | 9134 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 63938 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9134 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | BU79786 |
|---|---|
| 2nd row | QZ44356 |
| 3rd row | AI49188 |
| 4th row | WW63253 |
| 5th row | HB64268 |
| Value | Count | Frequency (%) |
| bu79786 | 1 | < 0.1% |
| oc83172 | 1 | < 0.1% |
| oe15005 | 1 | < 0.1% |
| rz33670 | 1 | < 0.1% |
| dy87989 | 1 | < 0.1% |
| ai49188 | 1 | < 0.1% |
| ww63253 | 1 | < 0.1% |
| hb64268 | 1 | < 0.1% |
| xz87318 | 1 | < 0.1% |
| ao98601 | 1 | < 0.1% |
| Other values (9124) | 9124 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 4750 | 7.4% |
| 5 | 4729 | 7.4% |
| 3 | 4718 | 7.4% |
| 9 | 4694 | 7.3% |
| 8 | 4686 | 7.3% |
| 6 | 4686 | 7.3% |
| 4 | 4646 | 7.3% |
| 1 | 4612 | 7.2% |
| 2 | 4473 | 7.0% |
| 0 | 3677 | 5.8% |
| Other values (27) | 18267 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 45671 | |
| Uppercase Letter | 18251 | 28.5% |
| Lowercase Letter | 16 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 746 | 4.1% |
| Z | 722 | 4.0% |
| M | 722 | 4.0% |
| F | 721 | 4.0% |
| E | 720 | 3.9% |
| C | 718 | 3.9% |
| P | 718 | 3.9% |
| N | 716 | 3.9% |
| L | 714 | 3.9% |
| X | 713 | 3.9% |
| Other values (16) | 11041 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 4750 | |
| 5 | 4729 | |
| 3 | 4718 | |
| 9 | 4694 | |
| 8 | 4686 | |
| 6 | 4686 | |
| 4 | 4646 | |
| 1 | 4612 | |
| 2 | 4473 | |
| 0 | 3677 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 16 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 45671 | |
| Latin | 18267 | 28.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| W | 746 | 4.1% |
| Z | 722 | 4.0% |
| M | 722 | 4.0% |
| F | 721 | 3.9% |
| E | 720 | 3.9% |
| C | 718 | 3.9% |
| P | 718 | 3.9% |
| N | 716 | 3.9% |
| L | 714 | 3.9% |
| X | 713 | 3.9% |
| Other values (17) | 11057 |
Common
| Value | Count | Frequency (%) |
| 7 | 4750 | |
| 5 | 4729 | |
| 3 | 4718 | |
| 9 | 4694 | |
| 8 | 4686 | |
| 6 | 4686 | |
| 4 | 4646 | |
| 1 | 4612 | |
| 2 | 4473 | |
| 0 | 3677 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63938 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 4750 | 7.4% |
| 5 | 4729 | 7.4% |
| 3 | 4718 | 7.4% |
| 9 | 4694 | 7.3% |
| 8 | 4686 | 7.3% |
| 6 | 4686 | 7.3% |
| 4 | 4646 | 7.3% |
| 1 | 4612 | 7.2% |
| 2 | 4473 | 7.0% |
| 0 | 3677 | 5.8% |
| Other values (27) | 18267 |
state
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| California | |
|---|---|
| Oregon | |
| Arizona | |
| Nevada | |
| Washington |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.9153711 |
| Min length | 6 |
Characters and Unicode
| Total characters | 72299 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Washington |
|---|---|
| 2nd row | Arizona |
| 3rd row | Nevada |
| 4th row | California |
| 5th row | Washington |
Common Values
| Value | Count | Frequency (%) |
| California | 3150 | |
| Oregon | 2601 | |
| Arizona | 1703 | |
| Nevada | 882 | 9.7% |
| Washington | 798 | 8.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| california | 3150 | |
| oregon | 2601 | |
| arizona | 1703 | |
| nevada | 882 | 9.7% |
| washington | 798 | 8.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10565 | |
| n | 9050 | |
| i | 8801 | |
| o | 8252 | |
| r | 7454 | |
| e | 3483 | 4.8% |
| g | 3399 | 4.7% |
| C | 3150 | 4.4% |
| f | 3150 | 4.4% |
| l | 3150 | 4.4% |
| Other values (10) | 11845 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 63165 | |
| Uppercase Letter | 9134 | 12.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 10565 | |
| n | 9050 | |
| i | 8801 | |
| o | 8252 | |
| r | 7454 | |
| e | 3483 | 5.5% |
| g | 3399 | 5.4% |
| f | 3150 | 5.0% |
| l | 3150 | 5.0% |
| z | 1703 | 2.7% |
| Other values (5) | 4158 | 6.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 3150 | |
| O | 2601 | |
| A | 1703 | |
| N | 882 | 9.7% |
| W | 798 | 8.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 72299 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 10565 | |
| n | 9050 | |
| i | 8801 | |
| o | 8252 | |
| r | 7454 | |
| e | 3483 | 4.8% |
| g | 3399 | 4.7% |
| C | 3150 | 4.4% |
| f | 3150 | 4.4% |
| l | 3150 | 4.4% |
| Other values (10) | 11845 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72299 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 10565 | |
| n | 9050 | |
| i | 8801 | |
| o | 8252 | |
| r | 7454 | |
| e | 3483 | 4.8% |
| g | 3399 | 4.7% |
| C | 3150 | 4.4% |
| f | 3150 | 4.4% |
| l | 3150 | 4.4% |
| Other values (10) | 11845 |
customer_lifetime_value
Real number (ℝ)
| Distinct | 8041 |
|---|---|
| Distinct (%) | 88.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8004.9405 |
| Minimum | 1898.0077 |
|---|---|
| Maximum | 83325.381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 1898.0077 |
|---|---|
| 5-th percentile | 2475.109 |
| Q1 | 3994.2518 |
| median | 5780.1822 |
| Q3 | 8962.167 |
| 95-th percentile | 22064.361 |
| Maximum | 83325.381 |
| Range | 81427.374 |
| Interquartile range (IQR) | 4967.9152 |
Descriptive statistics
| Standard deviation | 6870.9676 |
|---|---|
| Coefficient of variation (CV) | 0.85834087 |
| Kurtosis | 13.823533 |
| Mean | 8004.9405 |
| Median Absolute Deviation (MAD) | 2467.8936 |
| Skewness | 3.0322803 |
| Sum | 73117126 |
| Variance | 47210196 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7200.664877 | 6 | 0.1% |
| 17497.52201 | 6 | 0.1% |
| 2248.449633 | 6 | 0.1% |
| 8092.87696 | 6 | 0.1% |
| 6057.07208 | 6 | 0.1% |
| 4250.282624 | 6 | 0.1% |
| 8838.085637 | 6 | 0.1% |
| 22103.5072 | 6 | 0.1% |
| 26197.41498 | 6 | 0.1% |
| 2574.020376 | 6 | 0.1% |
| Other values (8031) | 9074 |
| Value | Count | Frequency (%) |
| 1898.007675 | 1 | < 0.1% |
| 1898.683686 | 1 | < 0.1% |
| 1904.000852 | 1 | < 0.1% |
| 1918.1197 | 1 | < 0.1% |
| 1940.981221 | 1 | < 0.1% |
| 1994.774936 | 1 | < 0.1% |
| 2004.350666 | 6 | |
| 2009.772923 | 1 | < 0.1% |
| 2030.783687 | 1 | < 0.1% |
| 2034.993043 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 83325.38119 | 1 | |
| 74228.51604 | 1 | |
| 73225.95652 | 1 | |
| 67907.2705 | 1 | |
| 66025.75407 | 1 | |
| 64618.75715 | 1 | |
| 61850.18803 | 1 | |
| 61134.68307 | 1 | |
| 60556.19213 | 1 | |
| 58753.88046 | 1 |
response
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 7826 | |
| True | 1308 | 14.3% |
coverage
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Basic | |
|---|---|
| Extended | |
| Premium |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 6.081016 |
| Min length | 5 |
Characters and Unicode
| Total characters | 55544 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Basic |
|---|---|
| 2nd row | Extended |
| 3rd row | Premium |
| 4th row | Basic |
| 5th row | Basic |
Common Values
| Value | Count | Frequency (%) |
| Basic | 5568 | |
| Extended | 2742 | |
| Premium | 824 | 9.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| basic | 5568 | |
| extended | 2742 | |
| premium | 824 | 9.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 6392 | |
| e | 6308 | |
| B | 5568 | |
| a | 5568 | |
| s | 5568 | |
| c | 5568 | |
| d | 5484 | |
| E | 2742 | 4.9% |
| x | 2742 | 4.9% |
| t | 2742 | 4.9% |
| Other values (5) | 6862 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 46410 | |
| Uppercase Letter | 9134 | 16.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 6392 | |
| e | 6308 | |
| a | 5568 | |
| s | 5568 | |
| c | 5568 | |
| d | 5484 | |
| x | 2742 | |
| t | 2742 | |
| n | 2742 | |
| m | 1648 | 3.6% |
| Other values (2) | 1648 | 3.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 5568 | |
| E | 2742 | |
| P | 824 | 9.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 55544 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 6392 | |
| e | 6308 | |
| B | 5568 | |
| a | 5568 | |
| s | 5568 | |
| c | 5568 | |
| d | 5484 | |
| E | 2742 | 4.9% |
| x | 2742 | 4.9% |
| t | 2742 | 4.9% |
| Other values (5) | 6862 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 55544 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 6392 | |
| e | 6308 | |
| B | 5568 | |
| a | 5568 | |
| s | 5568 | |
| c | 5568 | |
| d | 5484 | |
| E | 2742 | 4.9% |
| x | 2742 | 4.9% |
| t | 2742 | 4.9% |
| Other values (5) | 6862 |
education
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Bachelor | |
|---|---|
| College | |
| High School or Below | |
| Master | |
| Doctor |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 10.914057 |
| Min length | 6 |
Characters and Unicode
| Total characters | 99689 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bachelor |
|---|---|
| 2nd row | Bachelor |
| 3rd row | Bachelor |
| 4th row | Bachelor |
| 5th row | Bachelor |
Common Values
| Value | Count | Frequency (%) |
| Bachelor | 2748 | |
| College | 2681 | |
| High School or Below | 2622 | |
| Master | 741 | 8.1% |
| Doctor | 342 | 3.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bachelor | 2748 | |
| college | 2681 | |
| high | 2622 | |
| school | 2622 | |
| or | 2622 | |
| below | 2622 | |
| master | 741 | 4.4% |
| doctor | 342 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 16601 | |
| l | 13354 | |
| e | 11473 | |
| h | 7992 | |
| 7866 | ||
| r | 6453 | 6.5% |
| c | 5712 | 5.7% |
| B | 5370 | 5.4% |
| g | 5303 | 5.3% |
| a | 3489 | 3.5% |
| Other values (9) | 16076 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 77445 | |
| Uppercase Letter | 14378 | 14.4% |
| Space Separator | 7866 | 7.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 16601 | |
| l | 13354 | |
| e | 11473 | |
| h | 7992 | |
| r | 6453 | 8.3% |
| c | 5712 | 7.4% |
| g | 5303 | 6.8% |
| a | 3489 | 4.5% |
| i | 2622 | 3.4% |
| w | 2622 | 3.4% |
| Other values (2) | 1824 | 2.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 5370 | |
| C | 2681 | |
| H | 2622 | |
| S | 2622 | |
| M | 741 | 5.2% |
| D | 342 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 7866 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 91823 | |
| Common | 7866 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 16601 | |
| l | 13354 | |
| e | 11473 | |
| h | 7992 | |
| r | 6453 | 7.0% |
| c | 5712 | 6.2% |
| B | 5370 | 5.8% |
| g | 5303 | 5.8% |
| a | 3489 | 3.8% |
| C | 2681 | 2.9% |
| Other values (8) | 13395 |
Common
| Value | Count | Frequency (%) |
| 7866 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 99689 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 16601 | |
| l | 13354 | |
| e | 11473 | |
| h | 7992 | |
| 7866 | ||
| r | 6453 | 6.5% |
| c | 5712 | 5.7% |
| B | 5370 | 5.4% |
| g | 5303 | 5.3% |
| a | 3489 | 3.5% |
| Other values (9) | 16076 |
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Minimum | 2011-01-01 00:00:00 |
|---|---|
| Maximum | 2011-02-28 00:00:00 |
Histogram with fixed size bins (bins=50)
employmentstatus
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Employed | |
|---|---|
| Unemployed | |
| Medical Leave | 432 |
| Disabled | 405 |
| Retired | 282 |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 8.7129407 |
| Min length | 7 |
Characters and Unicode
| Total characters | 79584 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Employed |
|---|---|
| 2nd row | Unemployed |
| 3rd row | Employed |
| 4th row | Unemployed |
| 5th row | Employed |
Common Values
| Value | Count | Frequency (%) |
| Employed | 5698 | |
| Unemployed | 2317 | |
| Medical Leave | 432 | 4.7% |
| Disabled | 405 | 4.4% |
| Retired | 282 | 3.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| employed | 5698 | |
| unemployed | 2317 | |
| medical | 432 | 4.5% |
| leave | 432 | 4.5% |
| disabled | 405 | 4.2% |
| retired | 282 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12597 | |
| d | 9134 | |
| l | 8852 | |
| m | 8015 | |
| p | 8015 | |
| o | 8015 | |
| y | 8015 | |
| E | 5698 | |
| U | 2317 | 2.9% |
| n | 2317 | 2.9% |
| Other values (13) | 6609 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 69586 | |
| Uppercase Letter | 9566 | 12.0% |
| Space Separator | 432 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 12597 | |
| d | 9134 | |
| l | 8852 | |
| m | 8015 | |
| p | 8015 | |
| o | 8015 | |
| y | 8015 | |
| n | 2317 | 3.3% |
| a | 1269 | 1.8% |
| i | 1119 | 1.6% |
| Other values (6) | 2238 | 3.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 5698 | |
| U | 2317 | |
| M | 432 | 4.5% |
| L | 432 | 4.5% |
| D | 405 | 4.2% |
| R | 282 | 2.9% |
Space Separator
| Value | Count | Frequency (%) |
| 432 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 79152 | |
| Common | 432 | 0.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 12597 | |
| d | 9134 | |
| l | 8852 | |
| m | 8015 | |
| p | 8015 | |
| o | 8015 | |
| y | 8015 | |
| E | 5698 | |
| U | 2317 | 2.9% |
| n | 2317 | 2.9% |
| Other values (12) | 6177 |
Common
| Value | Count | Frequency (%) |
| 432 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79584 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 12597 | |
| d | 9134 | |
| l | 8852 | |
| m | 8015 | |
| p | 8015 | |
| o | 8015 | |
| y | 8015 | |
| E | 5698 | |
| U | 2317 | 2.9% |
| n | 2317 | 2.9% |
| Other values (13) | 6609 |
gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| F | |
|---|---|
| M |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9134 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| F | 4658 | |
| M | 4476 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 4658 | |
| m | 4476 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 4658 | |
| M | 4476 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 9134 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 4658 | |
| M | 4476 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9134 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 4658 | |
| M | 4476 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9134 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 4658 | |
| M | 4476 |
income
Real number (ℝ)
ZEROS
| Distinct | 5694 |
|---|---|
| Distinct (%) | 62.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37657.38 |
| Minimum | 0 |
|---|---|
| Maximum | 99981 |
| Zeros | 2317 |
| Zeros (%) | 25.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 33889.5 |
| Q3 | 62320 |
| 95-th percentile | 90374.35 |
| Maximum | 99981 |
| Range | 99981 |
| Interquartile range (IQR) | 62320 |
Descriptive statistics
| Standard deviation | 30379.905 |
|---|---|
| Coefficient of variation (CV) | 0.80674505 |
| Kurtosis | -1.094326 |
| Mean | 37657.38 |
| Median Absolute Deviation (MAD) | 28681 |
| Skewness | 0.28688728 |
| Sum | 3.4396251 × 108 |
| Variance | 9.2293861 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2317 | 25.4% |
| 95697 | 12 | 0.1% |
| 27972 | 7 | 0.1% |
| 25370 | 7 | 0.1% |
| 61108 | 7 | 0.1% |
| 40864 | 7 | 0.1% |
| 25965 | 7 | 0.1% |
| 20978 | 7 | 0.1% |
| 26876 | 7 | 0.1% |
| 33190 | 7 | 0.1% |
| Other values (5684) | 6749 |
| Value | Count | Frequency (%) |
| 0 | 2317 | |
| 10037 | 1 | < 0.1% |
| 10074 | 1 | < 0.1% |
| 10097 | 1 | < 0.1% |
| 10105 | 1 | < 0.1% |
| 10147 | 1 | < 0.1% |
| 10180 | 1 | < 0.1% |
| 10194 | 1 | < 0.1% |
| 10211 | 1 | < 0.1% |
| 10237 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99981 | 1 | < 0.1% |
| 99961 | 1 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99934 | 1 | < 0.1% |
| 99875 | 1 | < 0.1% |
| 99874 | 1 | < 0.1% |
| 99845 | 6 | |
| 99841 | 1 | < 0.1% |
| 99839 | 1 | < 0.1% |
| 99824 | 1 | < 0.1% |
location_code
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Suburban | |
|---|---|
| Rural | |
| Urban |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.8980731 |
| Min length | 5 |
Characters and Unicode
| Total characters | 63007 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Suburban |
|---|---|
| 2nd row | Suburban |
| 3rd row | Suburban |
| 4th row | Suburban |
| 5th row | Rural |
Common Values
| Value | Count | Frequency (%) |
| Suburban | 5779 | |
| Rural | 1773 | 19.4% |
| Urban | 1582 | 17.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| suburban | 5779 | |
| rural | 1773 | 19.4% |
| urban | 1582 | 17.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 13331 | |
| b | 13140 | |
| r | 9134 | |
| a | 9134 | |
| n | 7361 | |
| S | 5779 | |
| R | 1773 | 2.8% |
| l | 1773 | 2.8% |
| U | 1582 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 53873 | |
| Uppercase Letter | 9134 | 14.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 13331 | |
| b | 13140 | |
| r | 9134 | |
| a | 9134 | |
| n | 7361 | |
| l | 1773 | 3.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5779 | |
| R | 1773 | 19.4% |
| U | 1582 | 17.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 63007 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| u | 13331 | |
| b | 13140 | |
| r | 9134 | |
| a | 9134 | |
| n | 7361 | |
| S | 5779 | |
| R | 1773 | 2.8% |
| l | 1773 | 2.8% |
| U | 1582 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63007 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| u | 13331 | |
| b | 13140 | |
| r | 9134 | |
| a | 9134 | |
| n | 7361 | |
| S | 5779 | |
| R | 1773 | 2.8% |
| l | 1773 | 2.8% |
| U | 1582 | 2.5% |
marital_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Married | |
|---|---|
| Single | |
| Divorced |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.8797898 |
| Min length | 6 |
Characters and Unicode
| Total characters | 62840 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Married |
|---|---|
| 2nd row | Single |
| 3rd row | Married |
| 4th row | Married |
| 5th row | Single |
Common Values
| Value | Count | Frequency (%) |
| Married | 5298 | |
| Single | 2467 | |
| Divorced | 1369 | 15.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| married | 5298 | |
| single | 2467 | |
| divorced | 1369 | 15.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 11965 | |
| i | 9134 | |
| e | 9134 | |
| d | 6667 | |
| M | 5298 | |
| a | 5298 | |
| S | 2467 | 3.9% |
| n | 2467 | 3.9% |
| g | 2467 | 3.9% |
| l | 2467 | 3.9% |
| Other values (4) | 5476 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 53706 | |
| Uppercase Letter | 9134 | 14.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 11965 | |
| i | 9134 | |
| e | 9134 | |
| d | 6667 | |
| a | 5298 | |
| n | 2467 | 4.6% |
| g | 2467 | 4.6% |
| l | 2467 | 4.6% |
| v | 1369 | 2.5% |
| o | 1369 | 2.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 5298 | |
| S | 2467 | |
| D | 1369 | 15.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 62840 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 11965 | |
| i | 9134 | |
| e | 9134 | |
| d | 6667 | |
| M | 5298 | |
| a | 5298 | |
| S | 2467 | 3.9% |
| n | 2467 | 3.9% |
| g | 2467 | 3.9% |
| l | 2467 | 3.9% |
| Other values (4) | 5476 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 62840 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 11965 | |
| i | 9134 | |
| e | 9134 | |
| d | 6667 | |
| M | 5298 | |
| a | 5298 | |
| S | 2467 | 3.9% |
| n | 2467 | 3.9% |
| g | 2467 | 3.9% |
| l | 2467 | 3.9% |
| Other values (4) | 5476 |
monthly_premium_auto
Real number (ℝ)
| Distinct | 202 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93.219291 |
| Minimum | 61 |
|---|---|
| Maximum | 298 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 61 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 68 |
| median | 83 |
| Q3 | 109 |
| 95-th percentile | 163.35 |
| Maximum | 298 |
| Range | 237 |
| Interquartile range (IQR) | 41 |
Descriptive statistics
| Standard deviation | 34.407967 |
|---|---|
| Coefficient of variation (CV) | 0.3691078 |
| Kurtosis | 6.193605 |
| Mean | 93.219291 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 2.1235464 |
| Sum | 851465 |
| Variance | 1183.9082 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 65 | 348 | 3.8% |
| 66 | 307 | 3.4% |
| 71 | 304 | 3.3% |
| 73 | 302 | 3.3% |
| 63 | 289 | 3.2% |
| 69 | 287 | 3.1% |
| 67 | 284 | 3.1% |
| 61 | 277 | 3.0% |
| 72 | 275 | 3.0% |
| 68 | 270 | 3.0% |
| Other values (192) | 6191 |
| Value | Count | Frequency (%) |
| 61 | 277 | |
| 62 | 257 | |
| 63 | 289 | |
| 64 | 266 | |
| 65 | 348 | |
| 66 | 307 | |
| 67 | 284 | |
| 68 | 270 | |
| 69 | 287 | |
| 70 | 249 |
| Value | Count | Frequency (%) |
| 298 | 1 | < 0.1% |
| 297 | 2 | < 0.1% |
| 296 | 1 | < 0.1% |
| 295 | 2 | < 0.1% |
| 290 | 1 | < 0.1% |
| 287 | 1 | < 0.1% |
| 286 | 1 | < 0.1% |
| 285 | 2 | < 0.1% |
| 284 | 1 | < 0.1% |
| 283 | 7 |
months_since_last_claim
Real number (ℝ)
ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.097 |
| Minimum | 0 |
|---|---|
| Maximum | 35 |
| Zeros | 314 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 14 |
| Q3 | 23 |
| 95-th percentile | 33 |
| Maximum | 35 |
| Range | 35 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 10.073257 |
|---|---|
| Coefficient of variation (CV) | 0.66723564 |
| Kurtosis | -1.0736677 |
| Mean | 15.097 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.27858631 |
| Sum | 137896 |
| Variance | 101.4705 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 3 | 381 | 4.2% |
| 6 | 364 | 4.0% |
| 1 | 345 | 3.8% |
| 4 | 335 | 3.7% |
| 7 | 333 | 3.6% |
| 2 | 329 | 3.6% |
| 0 | 314 | 3.4% |
| 5 | 313 | 3.4% |
| 10 | 306 | 3.4% |
| 11 | 297 | 3.3% |
| Other values (26) | 5817 |
| Value | Count | Frequency (%) |
| 0 | 314 | |
| 1 | 345 | |
| 2 | 329 | |
| 3 | 381 | |
| 4 | 335 | |
| 5 | 313 | |
| 6 | 364 | |
| 7 | 333 | |
| 8 | 279 | |
| 9 | 250 |
| Value | Count | Frequency (%) |
| 35 | 142 | |
| 34 | 169 | |
| 33 | 179 | |
| 32 | 138 | |
| 31 | 190 | |
| 30 | 182 | |
| 29 | 206 | |
| 28 | 201 | |
| 27 | 182 | |
| 26 | 186 |
months_since_policy_inception
Real number (ℝ)
| Distinct | 100 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.064594 |
| Minimum | 0 |
|---|---|
| Maximum | 99 |
| Zeros | 83 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 24 |
| median | 48 |
| Q3 | 71 |
| 95-th percentile | 93 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 47 |
Descriptive statistics
| Standard deviation | 27.905991 |
|---|---|
| Coefficient of variation (CV) | 0.5805935 |
| Kurtosis | -1.1330459 |
| Mean | 48.064594 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 0.040164962 |
| Sum | 439022 |
| Variance | 778.74432 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59 | 142 | 1.6% |
| 61 | 128 | 1.4% |
| 50 | 125 | 1.4% |
| 44 | 115 | 1.3% |
| 3 | 114 | 1.2% |
| 10 | 114 | 1.2% |
| 56 | 112 | 1.2% |
| 38 | 110 | 1.2% |
| 34 | 109 | 1.2% |
| 35 | 109 | 1.2% |
| Other values (90) | 7956 |
| Value | Count | Frequency (%) |
| 0 | 83 | |
| 1 | 85 | |
| 2 | 89 | |
| 3 | 114 | |
| 4 | 91 | |
| 5 | 87 | |
| 6 | 73 | |
| 7 | 79 | |
| 8 | 81 | |
| 9 | 96 |
| Value | Count | Frequency (%) |
| 99 | 78 | |
| 98 | 54 | |
| 97 | 52 | |
| 96 | 67 | |
| 95 | 77 | |
| 94 | 72 | |
| 93 | 90 | |
| 92 | 74 | |
| 91 | 75 | |
| 90 | 84 |
number_of_open_complaints
Real number (ℝ)
ZEROS
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.384388 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 7252 |
| Zeros (%) | 79.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.91038353 |
|---|---|
| Coefficient of variation (CV) | 2.3683974 |
| Kurtosis | 7.7493085 |
| Mean | 0.384388 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.7832631 |
| Sum | 3511 |
| Variance | 0.82879817 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 7252 | |
| 1 | 1011 | 11.1% |
| 2 | 374 | 4.1% |
| 3 | 292 | 3.2% |
| 4 | 149 | 1.6% |
| 5 | 56 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 7252 | |
| 1 | 1011 | 11.1% |
| 2 | 374 | 4.1% |
| 3 | 292 | 3.2% |
| 4 | 149 | 1.6% |
| 5 | 56 | 0.6% |
| Value | Count | Frequency (%) |
| 5 | 56 | 0.6% |
| 4 | 149 | 1.6% |
| 3 | 292 | 3.2% |
| 2 | 374 | 4.1% |
| 1 | 1011 | 11.1% |
| 0 | 7252 |
number_of_policies
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9661704 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.3901818 |
|---|---|
| Coefficient of variation (CV) | 0.80581407 |
| Kurtosis | 0.36315659 |
| Mean | 2.9661704 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2533327 |
| Sum | 27093 |
| Variance | 5.7129691 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 1 | 3251 | |
| 2 | 2294 | |
| 3 | 1168 | 12.8% |
| 7 | 433 | 4.7% |
| 9 | 416 | 4.6% |
| 4 | 409 | 4.5% |
| 5 | 407 | 4.5% |
| 8 | 384 | 4.2% |
| 6 | 372 | 4.1% |
| Value | Count | Frequency (%) |
| 1 | 3251 | |
| 2 | 2294 | |
| 3 | 1168 | 12.8% |
| 4 | 409 | 4.5% |
| 5 | 407 | 4.5% |
| 6 | 372 | 4.1% |
| 7 | 433 | 4.7% |
| 8 | 384 | 4.2% |
| 9 | 416 | 4.6% |
| Value | Count | Frequency (%) |
| 9 | 416 | 4.6% |
| 8 | 384 | 4.2% |
| 7 | 433 | 4.7% |
| 6 | 372 | 4.1% |
| 5 | 407 | 4.5% |
| 4 | 409 | 4.5% |
| 3 | 1168 | 12.8% |
| 2 | 2294 | |
| 1 | 3251 |
policy_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Personal Auto | |
|---|---|
| Corporate Auto | |
| Special Auto | 378 |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 13.174075 |
| Min length | 12 |
Characters and Unicode
| Total characters | 120332 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corporate Auto |
|---|---|
| 2nd row | Personal Auto |
| 3rd row | Personal Auto |
| 4th row | Corporate Auto |
| 5th row | Personal Auto |
Common Values
| Value | Count | Frequency (%) |
| Personal Auto | 6788 | |
| Corporate Auto | 1968 | 21.5% |
| Special Auto | 378 | 4.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| auto | 9134 | |
| personal | 6788 | |
| corporate | 1968 | 10.8% |
| special | 378 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 19858 | |
| t | 11102 | |
| r | 10724 | |
| 9134 | ||
| A | 9134 | |
| u | 9134 | |
| a | 9134 | |
| e | 9134 | |
| l | 7166 | 6.0% |
| P | 6788 | 5.6% |
| Other values (7) | 19024 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 92930 | |
| Uppercase Letter | 18268 | 15.2% |
| Space Separator | 9134 | 7.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 19858 | |
| t | 11102 | |
| r | 10724 | |
| u | 9134 | |
| a | 9134 | |
| e | 9134 | |
| l | 7166 | 7.7% |
| n | 6788 | 7.3% |
| s | 6788 | 7.3% |
| p | 2346 | 2.5% |
| Other values (2) | 756 | 0.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 9134 | |
| P | 6788 | |
| C | 1968 | 10.8% |
| S | 378 | 2.1% |
Space Separator
| Value | Count | Frequency (%) |
| 9134 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 111198 | |
| Common | 9134 | 7.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 19858 | |
| t | 11102 | |
| r | 10724 | |
| A | 9134 | |
| u | 9134 | |
| a | 9134 | |
| e | 9134 | |
| l | 7166 | 6.4% |
| P | 6788 | 6.1% |
| n | 6788 | 6.1% |
| Other values (6) | 12236 |
Common
| Value | Count | Frequency (%) |
| 9134 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 120332 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 19858 | |
| t | 11102 | |
| r | 10724 | |
| 9134 | ||
| A | 9134 | |
| u | 9134 | |
| a | 9134 | |
| e | 9134 | |
| l | 7166 | 6.0% |
| P | 6788 | 5.6% |
| Other values (7) | 19024 |
policy
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Personal L3 | |
|---|---|
| Personal L2 | |
| Personal L1 | |
| Corporate L3 | |
| Corporate L2 | |
| Other values (4) |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 11.174075 |
| Min length | 10 |
Characters and Unicode
| Total characters | 102064 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corporate L3 |
|---|---|
| 2nd row | Personal L3 |
| 3rd row | Personal L3 |
| 4th row | Corporate L2 |
| 5th row | Personal L1 |
Common Values
| Value | Count | Frequency (%) |
| Personal L3 | 3426 | |
| Personal L2 | 2122 | |
| Personal L1 | 1240 | 13.6% |
| Corporate L3 | 1014 | 11.1% |
| Corporate L2 | 595 | 6.5% |
| Corporate L1 | 359 | 3.9% |
| Special L2 | 164 | 1.8% |
| Special L3 | 148 | 1.6% |
| Special L1 | 66 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| personal | 6788 | |
| l3 | 4588 | |
| l2 | 2881 | |
| corporate | 1968 | 10.8% |
| l1 | 1665 | 9.1% |
| special | 378 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 10724 | |
| o | 10724 | |
| L | 9134 | |
| e | 9134 | |
| 9134 | ||
| a | 9134 | |
| l | 7166 | |
| P | 6788 | |
| n | 6788 | |
| s | 6788 | |
| Other values (9) | 16550 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 65528 | |
| Uppercase Letter | 18268 | 17.9% |
| Space Separator | 9134 | 8.9% |
| Decimal Number | 9134 | 8.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 10724 | |
| o | 10724 | |
| e | 9134 | |
| a | 9134 | |
| l | 7166 | |
| n | 6788 | |
| s | 6788 | |
| p | 2346 | 3.6% |
| t | 1968 | 3.0% |
| c | 378 | 0.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 9134 | |
| P | 6788 | |
| C | 1968 | 10.8% |
| S | 378 | 2.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 4588 | |
| 2 | 2881 | |
| 1 | 1665 | 18.2% |
Space Separator
| Value | Count | Frequency (%) |
| 9134 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83796 | |
| Common | 18268 | 17.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 10724 | |
| o | 10724 | |
| L | 9134 | |
| e | 9134 | |
| a | 9134 | |
| l | 7166 | |
| P | 6788 | |
| n | 6788 | |
| s | 6788 | |
| p | 2346 | 2.8% |
| Other values (5) | 5070 |
Common
| Value | Count | Frequency (%) |
| 9134 | ||
| 3 | 4588 | |
| 2 | 2881 | 15.8% |
| 1 | 1665 | 9.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 102064 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 10724 | |
| o | 10724 | |
| L | 9134 | |
| e | 9134 | |
| 9134 | ||
| a | 9134 | |
| l | 7166 | |
| P | 6788 | |
| n | 6788 | |
| s | 6788 | |
| Other values (9) | 16550 |
renew_offer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Offer1 | |
|---|---|
| Offer2 | |
| Offer3 | |
| Offer4 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 54804 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Offer1 |
|---|---|
| 2nd row | Offer3 |
| 3rd row | Offer1 |
| 4th row | Offer1 |
| 5th row | Offer1 |
Common Values
| Value | Count | Frequency (%) |
| Offer1 | 3752 | |
| Offer2 | 2926 | |
| Offer3 | 1432 | 15.7% |
| Offer4 | 1024 | 11.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| offer1 | 3752 | |
| offer2 | 2926 | |
| offer3 | 1432 | 15.7% |
| offer4 | 1024 | 11.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 18268 | |
| O | 9134 | |
| e | 9134 | |
| r | 9134 | |
| 1 | 3752 | 6.8% |
| 2 | 2926 | 5.3% |
| 3 | 1432 | 2.6% |
| 4 | 1024 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 36536 | |
| Uppercase Letter | 9134 | 16.7% |
| Decimal Number | 9134 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3752 | |
| 2 | 2926 | |
| 3 | 1432 | 15.7% |
| 4 | 1024 | 11.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 18268 | |
| e | 9134 | |
| r | 9134 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 9134 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 45670 | |
| Common | 9134 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| f | 18268 | |
| O | 9134 | |
| e | 9134 | |
| r | 9134 |
Common
| Value | Count | Frequency (%) |
| 1 | 3752 | |
| 2 | 2926 | |
| 3 | 1432 | 15.7% |
| 4 | 1024 | 11.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 54804 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| f | 18268 | |
| O | 9134 | |
| e | 9134 | |
| r | 9134 | |
| 1 | 3752 | 6.8% |
| 2 | 2926 | 5.3% |
| 3 | 1432 | 2.6% |
| 4 | 1024 | 1.9% |
sales_channel
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Agent | |
|---|---|
| Branch | |
| Call Center | |
| Web |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.1503175 |
| Min length | 3 |
Characters and Unicode
| Total characters | 56177 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Agent |
|---|---|
| 2nd row | Agent |
| 3rd row | Agent |
| 4th row | Call Center |
| 5th row | Agent |
Common Values
| Value | Count | Frequency (%) |
| Agent | 3477 | |
| Branch | 2567 | |
| Call Center | 1765 | |
| Web | 1325 | 14.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| agent | 3477 | |
| branch | 2567 | |
| call | 1765 | |
| center | 1765 | |
| web | 1325 | 12.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8332 | |
| n | 7809 | |
| t | 5242 | |
| r | 4332 | |
| a | 4332 | |
| C | 3530 | 6.3% |
| l | 3530 | 6.3% |
| A | 3477 | 6.2% |
| g | 3477 | 6.2% |
| B | 2567 | 4.6% |
| Other values (5) | 9549 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43513 | |
| Uppercase Letter | 10899 | 19.4% |
| Space Separator | 1765 | 3.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8332 | |
| n | 7809 | |
| t | 5242 | |
| r | 4332 | |
| a | 4332 | |
| l | 3530 | |
| g | 3477 | |
| c | 2567 | 5.9% |
| h | 2567 | 5.9% |
| b | 1325 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 3530 | |
| A | 3477 | |
| B | 2567 | |
| W | 1325 | 12.2% |
Space Separator
| Value | Count | Frequency (%) |
| 1765 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 54412 | |
| Common | 1765 | 3.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8332 | |
| n | 7809 | |
| t | 5242 | |
| r | 4332 | |
| a | 4332 | |
| C | 3530 | |
| l | 3530 | |
| A | 3477 | |
| g | 3477 | |
| B | 2567 | 4.7% |
| Other values (4) | 7784 |
Common
| Value | Count | Frequency (%) |
| 1765 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 56177 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8332 | |
| n | 7809 | |
| t | 5242 | |
| r | 4332 | |
| a | 4332 | |
| C | 3530 | 6.3% |
| l | 3530 | 6.3% |
| A | 3477 | 6.2% |
| g | 3477 | 6.2% |
| B | 2567 | 4.6% |
| Other values (5) | 9549 |
total_claim_amount
Real number (ℝ)
| Distinct | 5106 |
|---|---|
| Distinct (%) | 55.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 434.08879 |
| Minimum | 0.099007 |
|---|---|
| Maximum | 2893.2397 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 71.5 KiB |
Quantile statistics
| Minimum | 0.099007 |
|---|---|
| 5-th percentile | 52.261227 |
| Q1 | 272.25824 |
| median | 383.94543 |
| Q3 | 547.51484 |
| 95-th percentile | 960.1154 |
| Maximum | 2893.2397 |
| Range | 2893.1407 |
| Interquartile range (IQR) | 275.25659 |
Descriptive statistics
| Standard deviation | 290.50009 |
|---|---|
| Coefficient of variation (CV) | 0.66921813 |
| Kurtosis | 5.979401 |
| Mean | 434.08879 |
| Median Absolute Deviation (MAD) | 144.05457 |
| Skewness | 1.7149658 |
| Sum | 3964967 |
| Variance | 84390.303 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 316.8 | 116 | 1.3% |
| 292.8 | 110 | 1.2% |
| 312 | 108 | 1.2% |
| 350.4 | 105 | 1.1% |
| 331.2 | 102 | 1.1% |
| 321.6 | 100 | 1.1% |
| 302.4 | 94 | 1.0% |
| 345.6 | 90 | 1.0% |
| 355.2 | 85 | 0.9% |
| 326.4 | 82 | 0.9% |
| Other values (5096) | 8142 |
| Value | Count | Frequency (%) |
| 0.099007 | 1 | |
| 0.382107 | 1 | |
| 0.42331 | 1 | |
| 0.517753 | 1 | |
| 0.769185 | 1 | |
| 0.887629 | 1 | |
| 1.208908 | 1 | |
| 1.332349 | 1 | |
| 1.48947 | 1 | |
| 1.587888 | 1 |
| Value | Count | Frequency (%) |
| 2893.239678 | 1 | |
| 2759.794354 | 1 | |
| 2552.343856 | 1 | |
| 2452.894264 | 1 | |
| 2345.413441 | 1 | |
| 2327.166394 | 1 | |
| 2306.508397 | 1 | |
| 2294.631639 | 1 | |
| 2275.265075 | 1 | |
| 2270.508697 | 1 |
vehicle_class
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Four-Door Car | |
|---|---|
| Two-Door Car | |
| SUV | |
| Sports Car | |
| Luxury SUV | 184 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 10.554303 |
| Min length | 3 |
Characters and Unicode
| Total characters | 96403 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Two-Door Car |
|---|---|
| 2nd row | Four-Door Car |
| 3rd row | Two-Door Car |
| 4th row | SUV |
| 5th row | Four-Door Car |
Common Values
| Value | Count | Frequency (%) |
| Four-Door Car | 4621 | |
| Two-Door Car | 1886 | |
| SUV | 1796 | 19.7% |
| Sports Car | 484 | 5.3% |
| Luxury SUV | 184 | 2.0% |
| Luxury Car | 163 | 1.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| car | 7154 | |
| four-door | 4621 | |
| suv | 1980 | 12.0% |
| two-door | 1886 | 11.4% |
| sports | 484 | 2.9% |
| luxury | 347 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 20005 | |
| r | 19113 | |
| 7338 | 7.6% | |
| C | 7154 | 7.4% |
| a | 7154 | 7.4% |
| - | 6507 | 6.7% |
| D | 6507 | 6.7% |
| u | 5315 | 5.5% |
| F | 4621 | 4.8% |
| S | 2464 | 2.6% |
| Other values (10) | 10225 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 55619 | |
| Uppercase Letter | 26939 | |
| Space Separator | 7338 | 7.6% |
| Dash Punctuation | 6507 | 6.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 20005 | |
| r | 19113 | |
| a | 7154 | 12.9% |
| u | 5315 | 9.6% |
| w | 1886 | 3.4% |
| p | 484 | 0.9% |
| t | 484 | 0.9% |
| s | 484 | 0.9% |
| x | 347 | 0.6% |
| y | 347 | 0.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 7154 | |
| D | 6507 | |
| F | 4621 | |
| S | 2464 | 9.1% |
| U | 1980 | 7.3% |
| V | 1980 | 7.3% |
| T | 1886 | 7.0% |
| L | 347 | 1.3% |
Space Separator
| Value | Count | Frequency (%) |
| 7338 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 82558 | |
| Common | 13845 | 14.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 20005 | |
| r | 19113 | |
| C | 7154 | 8.7% |
| a | 7154 | 8.7% |
| D | 6507 | 7.9% |
| u | 5315 | 6.4% |
| F | 4621 | 5.6% |
| S | 2464 | 3.0% |
| U | 1980 | 2.4% |
| V | 1980 | 2.4% |
| Other values (8) | 6265 | 7.6% |
Common
| Value | Count | Frequency (%) |
| 7338 | ||
| - | 6507 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 96403 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 20005 | |
| r | 19113 | |
| 7338 | 7.6% | |
| C | 7154 | 7.4% |
| a | 7154 | 7.4% |
| - | 6507 | 6.7% |
| D | 6507 | 6.7% |
| u | 5315 | 5.5% |
| F | 4621 | 4.8% |
| S | 2464 | 2.6% |
| Other values (10) | 10225 |
vehicle_size
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.5 KiB |
| Medsize | |
|---|---|
| Small | |
| Large |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.4066127 |
| Min length | 5 |
Characters and Unicode
| Total characters | 58518 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Medsize |
|---|---|
| 2nd row | Medsize |
| 3rd row | Medsize |
| 4th row | Medsize |
| 5th row | Medsize |
Common Values
| Value | Count | Frequency (%) |
| Medsize | 6424 | |
| Small | 1764 | 19.3% |
| Large | 946 | 10.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| medsize | 6424 | |
| small | 1764 | 19.3% |
| large | 946 | 10.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13794 | |
| M | 6424 | |
| d | 6424 | |
| s | 6424 | |
| i | 6424 | |
| z | 6424 | |
| l | 3528 | 6.0% |
| a | 2710 | 4.6% |
| S | 1764 | 3.0% |
| m | 1764 | 3.0% |
| Other values (3) | 2838 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 49384 | |
| Uppercase Letter | 9134 | 15.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 13794 | |
| d | 6424 | |
| s | 6424 | |
| i | 6424 | |
| z | 6424 | |
| l | 3528 | 7.1% |
| a | 2710 | 5.5% |
| m | 1764 | 3.6% |
| r | 946 | 1.9% |
| g | 946 | 1.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 6424 | |
| S | 1764 | 19.3% |
| L | 946 | 10.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 58518 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 13794 | |
| M | 6424 | |
| d | 6424 | |
| s | 6424 | |
| i | 6424 | |
| z | 6424 | |
| l | 3528 | 6.0% |
| a | 2710 | 4.6% |
| S | 1764 | 3.0% |
| m | 1764 | 3.0% |
| Other values (3) | 2838 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 58518 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 13794 | |
| M | 6424 | |
| d | 6424 | |
| s | 6424 | |
| i | 6424 | |
| z | 6424 | |
| l | 3528 | 6.0% |
| a | 2710 | 4.6% |
| S | 1764 | 3.0% |
| m | 1764 | 3.0% |
| Other values (3) | 2838 | 4.8% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| customer | state | customer_lifetime_value | response | coverage | education | effective_to_date | employmentstatus | gender | income | location_code | marital_status | monthly_premium_auto | months_since_last_claim | months_since_policy_inception | number_of_open_complaints | number_of_policies | policy_type | policy | renew_offer_type | sales_channel | total_claim_amount | vehicle_class | vehicle_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BU79786 | Washington | 2763.519279 | No | Basic | Bachelor | 2/24/11 | Employed | F | 56274 | Suburban | Married | 69 | 32 | 5 | 0 | 1 | Corporate Auto | Corporate L3 | Offer1 | Agent | 384.811147 | Two-Door Car | Medsize |
| 1 | QZ44356 | Arizona | 6979.535903 | No | Extended | Bachelor | 1/31/11 | Unemployed | F | 0 | Suburban | Single | 94 | 13 | 42 | 0 | 8 | Personal Auto | Personal L3 | Offer3 | Agent | 1131.464935 | Four-Door Car | Medsize |
| 2 | AI49188 | Nevada | 12887.431650 | No | Premium | Bachelor | 2/19/11 | Employed | F | 48767 | Suburban | Married | 108 | 18 | 38 | 0 | 2 | Personal Auto | Personal L3 | Offer1 | Agent | 566.472247 | Two-Door Car | Medsize |
| 3 | WW63253 | California | 7645.861827 | No | Basic | Bachelor | 1/20/11 | Unemployed | M | 0 | Suburban | Married | 106 | 18 | 65 | 0 | 7 | Corporate Auto | Corporate L2 | Offer1 | Call Center | 529.881344 | SUV | Medsize |
| 4 | HB64268 | Washington | 2813.692575 | No | Basic | Bachelor | 2/3/11 | Employed | M | 43836 | Rural | Single | 73 | 12 | 44 | 0 | 1 | Personal Auto | Personal L1 | Offer1 | Agent | 138.130879 | Four-Door Car | Medsize |
| 5 | OC83172 | Oregon | 8256.297800 | Yes | Basic | Bachelor | 1/25/11 | Employed | F | 62902 | Rural | Married | 69 | 14 | 94 | 0 | 2 | Personal Auto | Personal L3 | Offer2 | Web | 159.383042 | Two-Door Car | Medsize |
| 6 | XZ87318 | Oregon | 5380.898636 | Yes | Basic | College | 2/24/11 | Employed | F | 55350 | Suburban | Married | 67 | 0 | 13 | 0 | 9 | Corporate Auto | Corporate L3 | Offer1 | Agent | 321.600000 | Four-Door Car | Medsize |
| 7 | CF85061 | Arizona | 7216.100311 | No | Premium | Master | 1/18/11 | Unemployed | M | 0 | Urban | Single | 101 | 0 | 68 | 0 | 4 | Corporate Auto | Corporate L3 | Offer1 | Agent | 363.029680 | Four-Door Car | Medsize |
| 8 | DY87989 | Oregon | 24127.504020 | Yes | Basic | Bachelor | 1/26/11 | Medical Leave | M | 14072 | Suburban | Divorced | 71 | 13 | 3 | 0 | 2 | Corporate Auto | Corporate L3 | Offer1 | Agent | 511.200000 | Four-Door Car | Medsize |
| 9 | BQ94931 | Oregon | 7388.178085 | No | Extended | College | 2/17/11 | Employed | F | 28812 | Urban | Married | 93 | 17 | 7 | 0 | 8 | Special Auto | Special L2 | Offer2 | Branch | 425.527834 | Four-Door Car | Medsize |
| customer | state | customer_lifetime_value | response | coverage | education | effective_to_date | employmentstatus | gender | income | location_code | marital_status | monthly_premium_auto | months_since_last_claim | months_since_policy_inception | number_of_open_complaints | number_of_policies | policy_type | policy | renew_offer_type | sales_channel | total_claim_amount | vehicle_class | vehicle_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9124 | CB59349 | California | 16261.585500 | No | Extended | Master | 1/20/11 | Employed | M | 60646 | Suburban | Married | 134 | 31 | 42 | 0 | 2 | Personal Auto | Personal L3 | Offer2 | Agent | 643.200000 | SUV | Medsize |
| 9125 | RX91025 | California | 19872.262000 | No | Premium | High School or Below | 1/31/11 | Unemployed | M | 0 | Suburban | Single | 185 | 26 | 35 | 0 | 2 | Personal Auto | Personal L3 | Offer1 | Agent | 1950.725547 | SUV | Small |
| 9126 | AC13887 | California | 4628.995325 | No | Basic | Bachelor | 1/9/11 | Unemployed | M | 0 | Suburban | Single | 67 | 25 | 21 | 0 | 4 | Corporate Auto | Corporate L1 | Offer1 | Branch | 482.400000 | Two-Door Car | Medsize |
| 9127 | TF56202 | California | 5032.165498 | No | Basic | College | 2/12/11 | Employed | M | 66367 | Suburban | Divorced | 64 | 6 | 48 | 0 | 3 | Personal Auto | Personal L3 | Offer2 | Call Center | 307.200000 | Two-Door Car | Small |
| 9128 | YM19146 | California | 4100.398533 | No | Premium | College | 1/6/11 | Employed | F | 47761 | Suburban | Single | 104 | 16 | 58 | 0 | 1 | Personal Auto | Personal L2 | Offer1 | Branch | 541.282007 | Four-Door Car | Large |
| 9129 | LA72316 | California | 23405.987980 | No | Basic | Bachelor | 2/10/11 | Employed | M | 71941 | Urban | Married | 73 | 18 | 89 | 0 | 2 | Personal Auto | Personal L1 | Offer2 | Web | 198.234764 | Four-Door Car | Medsize |
| 9130 | PK87824 | California | 3096.511217 | Yes | Extended | College | 2/12/11 | Employed | F | 21604 | Suburban | Divorced | 79 | 14 | 28 | 0 | 1 | Corporate Auto | Corporate L3 | Offer1 | Branch | 379.200000 | Four-Door Car | Medsize |
| 9131 | TD14365 | California | 8163.890428 | No | Extended | Bachelor | 2/6/11 | Unemployed | M | 0 | Suburban | Single | 85 | 9 | 37 | 3 | 2 | Corporate Auto | Corporate L2 | Offer1 | Branch | 790.784983 | Four-Door Car | Medsize |
| 9132 | UP19263 | California | 7524.442436 | No | Extended | College | 2/3/11 | Employed | M | 21941 | Suburban | Married | 96 | 34 | 3 | 0 | 3 | Personal Auto | Personal L2 | Offer3 | Branch | 691.200000 | Four-Door Car | Large |
| 9133 | Y167826 | California | 2611.836866 | No | Extended | College | 2/14/11 | Unemployed | M | 0 | Suburban | Single | 77 | 3 | 90 | 0 | 1 | Corporate Auto | Corporate L3 | Offer4 | Call Center | 369.600000 | Two-Door Car | Medsize |